CREATE TABLE [dbo].[MemorialTribute]
(
[MemorialTributeKey] [uniqueidentifier] NOT NULL,
[FRProductKey] [uniqueidentifier] NULL,
[NotificationGroupKey] [uniqueidentifier] NULL,
[MemorialTributeCodeKey] [uniqueidentifier] NOT NULL,
[Description] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UseDefaultDescriptionFlag] [bit] NOT NULL CONSTRAINT [DF_MemorialTribute_UseDefaultDescriptionFlag] DEFAULT ((0)),
[HonoreeContactKey] [uniqueidentifier] NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[MemorialTribute] ADD CONSTRAINT [PK_MemorialTribute] PRIMARY KEY CLUSTERED ([MemorialTributeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [UN_MemorialTribute_HonoreeContactKey] ON [dbo].[MemorialTribute] ([HonoreeContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MemorialTribute_MemorialTributeCodeKey] ON [dbo].[MemorialTribute] ([MemorialTributeCodeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MemorialTribute_NotificationGroupKey] ON [dbo].[MemorialTribute] ([NotificationGroupKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MemorialTribute] ADD CONSTRAINT [FK_MemorialTribute_ContactMain] FOREIGN KEY ([HonoreeContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO
ALTER TABLE [dbo].[MemorialTribute] ADD CONSTRAINT [FK_MemorialTribute_GroupMain_Notification] FOREIGN KEY ([NotificationGroupKey]) REFERENCES [dbo].[GroupMain] ([GroupKey])
GO
ALTER TABLE [dbo].[MemorialTribute] ADD CONSTRAINT [FK_MemorialTribute_MemorialTributeCodeRef] FOREIGN KEY ([MemorialTributeCodeKey]) REFERENCES [dbo].[MemorialTributeCodeRef] ([MemorialTributeCodeKey])
GO